Limitations and considerations

The following limitations apply when using Google Cloud SQL for PostgreSQL as a source:

The Google Cloud SQL for PostgreSQL source endpoint supports Full Load replication only (i.e. the Apply Changes and Store Changes replication options are not supported).
The database name cannot include a semi-colon (;).
Replication of multiple tables with the same name but a different case (e.g. table1, TABLE1 and Table1) may cause unpredictable behavior and is therefore not supported.
Deferred Constraints are not supported.
Partitioned tables
- CDC is not supported.
- On Postgres 9.6, when performing a Full Load replication of partitioned tables, the parent table will be created, and separate child tables will be created for each partition.
When using the Parallel Load feature, table segmentation according to partitions or sub-partitions is not supported.
When using filters that do not contain a Primary Key, DELETE operations will not be captured.
A DDL operation that occurs during Full Load, but that was not preceded by a DML operation will not be captured.
PostGIS datatypes are not supported.
Unique Indexes with CASE expressions are not supported.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!